Implementing spatial datawarehouse hierarchies in object-relational DBMSs

نویسندگان

  • Elzbieta Malinowski
  • Esteban Zimányi
چکیده

Spatial Data Warehouses (SDWs) allow to analyze historical data represented in a space supporting the decision-making process. SDW applications require a multidimensional view of data that includes dimensions with hierarchies and facts with associated measures. In particular, hierarchies are important since traversing them users can analyze detailed and aggregated measures. To better represent users’ requirements for SDWs, the conceptual model with spatial support should be used. Afterwards, the conceptual schema is translated to the logical and physical schemas. However, during the translation process the semantics can be lost. In this paper, we present the translation of spatial hierarchies from the conceptual to physical schemas represented in the MultiDimER model and Oracle 10g Spatial, respectively. Further, to ensure the semantic equivalence between the conceptual and the physical schemas, integrity constraints are exemplified mainly using triggers.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Logical Representation of a Conceptual Model for Spatial Data Warehouses

The MultiDimER model is a conceptual model used for representing a multidimensional view of data for Data Warehouse (DW) and On-Line Analytical Processing (OLAP) applications. This model includes a spatial extension allowing spatiality in levels, hierarchies, fact relationships, and measures. In this way decisionmaking users can represent in an abstract manner their analysis needs without consi...

متن کامل

AN OVERVIEW OF THE OBJECT PROTOCOL MODEL (OPM) AND THE OPM DATA MANAGEMENT TOOLSy

| In this paper, we overview the Object-Protocol Model (OPM) and a suite of data management tools based on OPM. OPM is a data model that allows specifying database structures and queries in terms of objects and protocols speciic to scientiic (e.g., molecular biology laboratory) applications. Thus, scientiic experiments and their resources can be described using OPM in a uniied way. OPM data man...

متن کامل

Object-Relational DBMS

In this paper we present a classification of the applications that require DBMS technology and show where Relational DBMSs, Object-oriented DBMSs and ObjectRelational DBMSs fit. Our purpose is to indicate the kinds of problems each kind of DBMS solves. As will be seen, "one size does not fit all"; i.e. there is no DBMS that solves all the applications we are going to discuss. Then, we indicate ...

متن کامل

Exploiting the Functionality of Object-Oriented Database Management Systems for Information Retrieval

In this paper, we present the approach of FIRE to utilizing an object-oriented Database Management System (DBMS) for Information Retrieval (IR) purposes. First, a comprehensive overview of previous attempts to use DBMSs for implementing IR systems is given. Next, di erences between DBMSs and IR systems, with regard to indexing and retrieval, are discussed. In addition, some shortcomings of DBMS...

متن کامل

The exploration of a category theory-based virtual geometrical product specification system for design and manufacturing

ions such as inheritance are more naturally represented by graphs than as sets (Levene and Poulovassilis, 1991 [33]; Poulovassilis and Levene, 1994 [34]). (4) Data modellings in object-relational DBMSs still have weaknesses in semantic supports. For example, because the functional data model is the “lowest common denominator” of data models (refer to Section 2.2.3.1), there is lack of semantic ...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2007